<?php
// otpremnica_print.php

// Uključivanje konfiguracijskog fajla
include('config.php');

// Provjera da li je doc_id proslijeđen
if (!isset($_GET['doc_id'])) {
    die("ID otpremnice nije definiran.");
}

$doc_id = intval($_GET['doc_id']);

// Dohvat zaglavlja otpremnice zajedno s podacima o klijentu
$stmt = $conn->prepare("
    SELECT dh.doc_number, dh.doc_date, dh.note, dh.total_net, 
           k.naziv_klijenta, k.adresa, k.mjesto, k.jib, k.pib
    FROM document_header dh
    LEFT JOIN klijenti k ON dh.client_id = k.sifra
    WHERE dh.id = ? AND dh.document_type_id = 4
");
if (!$stmt) {
    die("Priprema upita nije uspjela: " . $conn->error);
}
$stmt->bind_param("i", $doc_id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows === 0) {
    die("Otpremnica nije pronađena.");
}
$header = $result->fetch_assoc();
$stmt->close();

// Razdvajanje vrijednosti note na "Na lokaciju" i "Napomena"
// Pretpostavljamo da su vrijednosti spremljene kao "na_lokaciju - napomena"
$na_lokaciju_value = "";
$napomena_value = "";
if (!empty($header['note'])) {
    $parts = explode(" - ", $header['note']);
    $na_lokaciju_value = $parts[0];
    $napomena_value = isset($parts[1]) ? $parts[1] : "";
}

// Dohvat stavki otpremnice
$stmt = $conn->prepare("SELECT item_id, item_name, item_measure, quantity FROM document_item WHERE document_id = ?");
if (!$stmt) {
    die("Priprema upita za stavke nije uspjela: " . $conn->error);
}
$stmt->bind_param("i", $doc_id);
$stmt->execute();
$items_result = $stmt->get_result();
$items = array();
while ($row = $items_result->fetch_assoc()) {
    $items[] = $row;
}
$stmt->close();

// Formatiranje datuma u dd.mm.yyyy
$formattedDate = date('d.m.Y', strtotime($header['doc_date']));

// Prikaz broja otpremnice s tekućom godinom (npr. 1/2025)
$docNumberWithYear = htmlspecialchars($header['doc_number']) . "/" . date("Y");

// Dohvat napomene iz tablice "napomena"
$napomenaText = "";
$queryNapomena = "SELECT tekst_napomena FROM napomena LIMIT 1";
$resultNapomena = $conn->query($queryNapomena);
if ($resultNapomena && $resultNapomena->num_rows > 0) {
    $napomenaRow = $resultNapomena->fetch_assoc();
    $napomenaText = $napomenaRow['tekst_napomena'];
}
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>Otpremnica <?php echo $docNumberWithYear; ?></title>
  <style>
    html, body {
      margin: 0;
      padding: 0;
      height: 100%;
      font-family: Arial, sans-serif;
      font-size: 14px;
    }
    .wrapper {
      display: flex;
      flex-direction: column;
      min-height: 100vh;
    }
    .page-content {
      flex: 1;
      padding: 20px;
      box-sizing: border-box;
    }
    .header, .footer {
      text-align: center;
    }
    .info-container {
      display: flex;
      justify-content: space-between;
      margin-bottom: 20px;
    }
    .info-left, .info-right {
      width: 48%;
    }
    .info-left p, .info-right p {
      margin: 4px 0;
    }
    /* Ispis JIB i PIB jedan ispod drugog */
    .info-right p.jib-pib {
      margin: 2px 0;
    }
    .document-items {
      margin-top: 20px;
    }
    table {
      width: 100%;
      border-collapse: collapse;
      margin-top: 10px;
      font-size: 13px;
    }
    table, th, td {
      border: 1px solid #000;
    }
    thead {
      background-color: #ccc;
    }
    th, td {
      padding: 8px;
      text-align: left;
    }
    /* Centriranje teksta u koloni "Naziv" */
    table th:nth-child(3),
    table td:nth-child(3) {
      text-align: center;
    }
    .rekap {
      margin-top: 20px;
      font-size: 16px;
      text-align: right;
    }
    .signature {
      margin-top: 40px;
      display: flex;
      justify-content: space-between;
    }
    .signature div {
      width: 45%;
      text-align: center;
    }
    .signature-line {
      border-top: 1px solid #000;
      width: 100px; /* kraća linija */
      margin: 5px auto 0;
    }
    .footer {
      border-top: 1px solid #000;
      font-size: 12px;
      padding: 5px 0;
    }
    /* Dugme za ispis ne prikazuje se na papiru */
    .no-print {
      margin: 10px 20px;
      text-align: right;
    }
    @media print {
      .no-print { display: none; }
    }
    /* Stil za blok napomene */
    .napomena {
      margin-top: 20px;
      text-align: left;
      font-size: 14px;
    }
  </style>
</head>
<body>
  <div class="wrapper">
    <?php include('header.html'); ?>
    
    <!-- Dugme za ispis -->
    <div class="no-print">
      <button onclick="window.print()">Štampaj otpremnicu</button>
    </div>
    
    <div class="page-content">
      <div class="info-container">
        <!-- Lijeva strana: podaci otpremnice -->
        <div class="info-left">
          <p><strong>OTPREMNICA Broj:</strong> <?php echo $docNumberWithYear; ?></p>
          <p><strong>Datum:</strong> <?php echo htmlspecialchars($formattedDate); ?></p>
          <p><strong>Sa lokacije:</strong> Skladište: "ELEKTRO PLUS" d.o.o. Mrkonjić Grad</p>
          <p><strong>Na lokaciju:</strong> <?php echo htmlspecialchars($na_lokaciju_value); ?></p>
          <p><strong>Napomena:</strong> <?php echo htmlspecialchars($napomena_value); ?></p>
        </div>
        <!-- Desna strana: podaci o klijentu -->
        <div class="info-right">
          <?php if (!empty($header['naziv_klijenta'])): ?>
            <p><strong>Klijent:</strong> <?php echo htmlspecialchars($header['naziv_klijenta']); ?></p>
            <p><strong>Adresa:</strong> <?php echo htmlspecialchars($header['adresa']); ?></p>
            <p><strong>Mjesto:</strong> <?php echo htmlspecialchars($header['mjesto']); ?></p>
            <p class="jib-pib"><strong>JIB:</strong> <?php echo htmlspecialchars($header['jib']); ?></p>
            <p class="jib-pib"><strong>PIB:</strong> <?php echo htmlspecialchars($header['pib']); ?></p>
          <?php else: ?>
            <p><em>Nema podataka o klijentu.</em></p>
          <?php endif; ?>
        </div>
      </div>
      
      <!-- Stavke otpremnice -->
      <div class="document-items">
        <table>
          <thead>
            <tr>
              <th>Red.br</th>
              <th>Šifra artikla</th>
              <th>Naziv</th>
              <th>JM</th>
              <th>Količina</th>
            </tr>
          </thead>
          <tbody>
            <?php
            $redniBr = 1;
            foreach ($items as $item) {
                echo '<tr>';
                echo '<td>' . $redniBr++ . '</td>';
                echo '<td>' . htmlspecialchars($item['item_id']) . '</td>';
                echo '<td>' . htmlspecialchars($item['item_name']) . '</td>';
                echo '<td>' . htmlspecialchars($item['item_measure']) . '</td>';
                echo '<td>' . htmlspecialchars($item['quantity']) . '</td>';
                echo '</tr>';
            }
            ?>
          </tbody>
        </table>
      </div>
      
      <!-- Napomena ispod stavki, dohvaćena iz tablice "napomena" -->
      <div class="napomena">
        <p><strong>Napomena:</strong> <?php echo htmlspecialchars($napomenaText); ?></p>
      </div>
      
      <!-- Rekapitulacija -->
      <div class="rekap">
        <p><strong>UKUPNO:</strong> <?php echo htmlspecialchars($header['total_net']); ?></p>
      </div>
      
      <!-- Potpisi -->
      <div class="signature">
        <div>
          <p>Primio</p>
          <div class="signature-line"></div>
        </div>
        <div>
          <p>Otpremio</p>
          <div class="signature-line"></div>
        </div>
      </div>
    </div>
    
    <?php include('footer.html'); ?>
  </div>
</body>
</html>